/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_cust_group.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_CUST_GROUP
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_cust_group.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_CUST_GROUP::CTable_PPM_CUST_GROUP( )
 :NPCRecordSet( )
{
  setTableName( "PPM_CUST_GROUP" );
  prepareTable();
  prepareQuery();
 
  CUST_GROUP_ID.setField( "CUST_GROUP_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CUST_GROUP_ID );
  makeKeyItem( CUST_GROUP_ID ); 
  CUST_GROUP_FEATURE_ID.setField( "CUST_GROUP_FEATURE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( CUST_GROUP_FEATURE_ID );
  CUST_GROUP_CODE.setField( "CUST_GROUP_CODE", DATA_CHAR, 30, 0 );
  makeTableItem( CUST_GROUP_CODE );
  CUST_GROUP_NAME.setField( "CUST_GROUP_NAME", DATA_CHAR, 32, 0 );
  makeTableItem( CUST_GROUP_NAME );
  CUST_GROUP_DESC.setField( "CUST_GROUP_DESC", DATA_CHAR, 2048, 0 );
  makeTableItem( CUST_GROUP_DESC );
  EFFECT_DATE.setField( "EFFECT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFFECT_DATE );
  EXPIRE_DATE.setField( "EXPIRE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXPIRE_DATE );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
}


CTable_PPM_CUST_GROUP::CTable_PPM_CUST_GROUP( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_CUST_GROUP" );
  prepareTable();
  prepareQuery();
 
  CUST_GROUP_ID.setField( "CUST_GROUP_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CUST_GROUP_ID );
  makeKeyItem( CUST_GROUP_ID ); 
  CUST_GROUP_FEATURE_ID.setField( "CUST_GROUP_FEATURE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( CUST_GROUP_FEATURE_ID );
  CUST_GROUP_CODE.setField( "CUST_GROUP_CODE", DATA_CHAR, 30, 0 );
  makeTableItem( CUST_GROUP_CODE );
  CUST_GROUP_NAME.setField( "CUST_GROUP_NAME", DATA_CHAR, 32, 0 );
  makeTableItem( CUST_GROUP_NAME );
  CUST_GROUP_DESC.setField( "CUST_GROUP_DESC", DATA_CHAR, 2048, 0 );
  makeTableItem( CUST_GROUP_DESC );
  EFFECT_DATE.setField( "EFFECT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFFECT_DATE );
  EXPIRE_DATE.setField( "EXPIRE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXPIRE_DATE );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
}

CTable_PPM_CUST_GROUP::~CTable_PPM_CUST_GROUP( )
{
    close();
}

